SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlLogros
AS
SELECT     dbo.tb_LOGROS.logro_id AS ID, dbo.tb_LOGROS.indicador_id AS Indicador, dbo.tb_INDICADOR.Descripcion, dbo.tb_LOGROS.cantidad, 
                      dbo.tb_LOGROS.monto, dbo.tb_LOGROS.anio_logro AS Año
FROM         dbo.tb_LOGROS INNER JOIN
                      dbo.tb_INDICADOR ON dbo.tb_LOGROS.indicador_id = dbo.tb_INDICADOR.indicador_id
GO
GRANT SELECT ON  [dbo].[vwlLogros] TO [MCEEjecutivo]
GRANT SELECT ON  [dbo].[vwlLogros] TO [SoloVer]
GO
